package com.embrion.db;

public class QueryConstant {
	
	public static final String GET_PROFESSORE = "SELECT * FROM  professore WHERE username = ? and passwd = ? " ;
	public static final String SELECT_SCUOLA_DEL_PROFESSORE = "SELECT id, nome_scuola, citta FROM scuola WHERE id = ? ;";
	public static final String SELECT_CLASSI_DELLA_SCUOLA = "SELECT id, id_scuola, nome_classe FROM classe  WHERE id_scuola = ? ;";
	public static final String SELECT_ALUNNI_DELLA_CLASSE = "SELECT id, id_classe, nome, cognome FROM alunno WHERE id_classe = ? order by cognome,nome ;";
	
	
	
}